package com.suineg.pms.repository.fee;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.suineg.pms.entity.fee.FeePlan;

/**
 * 收费方案 DAO
 *@author Suine
 */
public interface FeePlanDao extends PagingAndSortingRepository<FeePlan,Long>,JpaSpecificationExecutor<FeePlan>{
	FeePlan findByName(String name);
	
	@Query(value="from FeePlan where flag = 1 order by id")
	List<FeePlan> findByPublic();
	
}

